Create Line and Clustered Chart for Total Accidents by Weather Conditions 16

To create Create Line and Clustered Chart for Total Accidents by Weather Conditions please follow the steps below.

Step 1: Weather condition dimension has a lot of values. So the first step here is to group Weather conditions into similar values. On the US_Accidents_Dec20 table, right click on Weather_Condition, then click on New Group. Using the table below as a guide, select the Ungrouped values, click 'Group', then give a name to the Group. (See GIF below)

Note:

Select multiple items by holding the Ctrl button before Grouping
The table below shoes the Group name and the values that should belong to each Group
Click 'OK' when you are done grouping all items

Step 2: In the visualization pane, select the Line and stacked column chart. In the 'MyMeasures' Table, click 'AccidentsPerDay' and 'HighSeverityPerDay' as Column values. Drag and drop %YOYHighSeverity and %YOYAccidentsPerDay into the Line values. Drag and drop %HighSeverity to the Tooltips. In the US_Accidents_Dec20 table, click on 'Weather_Condition (Groups)' and 'Weather_Condition' to add to the Shared axis. (See screenshot below)

Step 3: Format chart using screenshots and GIF below as a guide.

I. General

II. X Axis, Y Axis

III. Data colors

III. Data labels, Shapes, Background and Shadow

IV. Title text

Step 4: Save your report 'Ctrl + S'

For tips on how to create and use combo chart in Power BI, visit: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

For tips on how to Use grouping and binning in Power BI Desktop, visit: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning